#coding:utf-8
#创建扫描机表
CreateServersTableSQL = '''CREATE TABLE SERVERS (
    ID       INTEGER       PRIMARY KEY AUTOINCREMENT
                           NOT NULL,
    IP       VARCHAR (20)  UNIQUE
                           NOT NULL,
    PASSWORD VARCHAR (100) NOT NULL,
    STATUS   INTEGER       NOT NULL
);
'''
#创建任务表
CreateTaskTableSQL = '''CREATE TABLE TASK (
    ID      INTEGER PRIMARY KEY AUTOINCREMENT
                    NOT NULL,
    NAME    VARCHAR NOT NULL,
    CONFIG  TEXT    NOT NULL,
    RESULTS TEXT
);
'''
#创建任务回调日志表
CreateCallBackLogsTableSQL = '''CREATE TABLE TASKLOGS (
    ID     INTEGER      PRIMARY KEY AUTOINCREMENT,
    TASKID INTEGER,
    IP     VARCHAR (20),
    LOG    TEXT
);
'''